Hi~大家好，我今天想要分享的實作包括如下:

< Cosmos DB >

1. 如何建立Azure Cosmos DB Account (建立時會花一點時間)

• 路徑: Home > Resource groups > create Azure Cosmos DB

< Basics >

• Account Name: test-life-db1-dev (自己取)
• Location: (Asia Pacific) Southeast Asia
• Capacity mode:
  • Provisioned throughput
  • Serverless (o)

< Backup Policy >

• Backup storage redundancy:
  • Locally-redundant backup storage (o)

< Tags >

• Service: test-life-db1-dev
• Owner: life

2. 在Azure Cosmos DB裡面建立Database (DB)

• 路徑: test-life-db1-dev > Data Explorer
• 按步點選: New Container -> New Database -> Database id -> New Database -> 輸入TestLifeDb (自己取)

3. 在Azure Cosmos DB裡面建立Container (Table)

• 路徑: test-life-db1-dev > Data Explorer
• 按步點選: New Container -> New Container -> Database id (點選Use existing) -> 輸入TestLifeDb -> Container id -> 輸入testLifeData -> Partition key -> 輸入/user_id

4. 在Azure Cosmos DB裡面建立Item (Data)

• 路徑: test-life-db1-dev > Data Explorer
• 按步點選: SQL API -> TestLifeDb -> testLifeData -> Items -> New Item -> 一筆一筆輸入新資料 (JSON的格式) -> Save
• 第一筆資料:
  {
  "id": "1",
  "user_id": "123"
  }
• 第二筆資料:
  {
  "id": "2",
  "user_id": "234"
  }
• 第三筆資料:
  {
  "id": "3",
  "user_id": "345"
  }

5. 在Azure Cosmos DB裡面Query Item (Select Data)

• 路徑: test-life-db1-dev > Data Explorer
• 按步點選: SQL API -> TestLifeDb -> testLifeData -> Items -> Edit Filter -> 輸入SELECT * FROM c where c.user_id = "123" -> Apply Filter
• 備註 : 只有在 Items 下面的資料才可以直接修改

6. 接著在Azure Cosmos DB裡面Update Item (Update Data)

• 路徑: test-life-db1-dev > Data Explorer
• 按步點選: SQL API -> TestLifeDb -> testLifeData -> Items -> Edit Filter -> 輸入SELECT * FROM c where c.user_id = "123" -> Apply Filter -> 修改資料 -> Update

7. 接著在Azure Cosmos DB裡面Delete Item (Delete Data)

• 路徑: test-life-db1-dev > Data Explorer
• 按步點選: SQL API -> TestLifeDb -> testLifeData -> Items -> Edit Filter -> 輸入SELECT * FROM c where c.user_id = "123" -> Apply Filter -> 修改資料 -> Update -> Edit Filter -> 輸入SELECT * FROM c where c.user_id = "1" -> 點選Item -> Delete

8. 在Azure Cosmos DB裡面用SQL Query查詢 (Select Data)

• 路徑: test-life-db1-dev > Data Explorer
• 按步點選: SQL API -> TestLifeDb -> testLifeData -> (右鍵)New SQL Query -> 輸入SELECT * FROM c WHERE c.user_id = "1" -> Execute Selection -> (查詢筆數)輸入SELECT COUNT(1) FROM c -> Execute Query -> 點選 Query Stats 查看消耗的 RU 數量
• 備註 : 透過 SQL Query 查詢的資料不能直接修改